﻿<%@ Page Title="" Language="C#" MasterPageFile="~/admin/adminMasterPage.master" AutoEventWireup="true" CodeFile="editsb.aspx.cs" Inherits="admin_sbList" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">

</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server"><div class="Body_Title">
    系统信息管理 》》设备信息一览</div>

            <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                DataSourceID="SqlDataSourceSB" EnableModelValidation="True">
                <Columns>
                    <asp:BoundField DataField="sbID" HeaderText="sbID" SortExpression="sbID" />
                    <asp:HyperLinkField DataNavigateUrlFields="sbID" 
                        DataNavigateUrlFormatString="addSb.aspx?id={0}" DataTextField="s_Name" 
                        HeaderText="设备名" />
                    <asp:BoundField DataField="j_Name" HeaderText="j_Name" 
                        SortExpression="j_Name" />
                    <asp:BoundField DataField="c_Name" HeaderText="c_Name" 
                        SortExpression="c_Name" />
                    <asp:BoundField DataField="s_zy" HeaderText="s_zy" SortExpression="s_zy" />
                    <asp:BoundField DataField="s_remark" HeaderText="s_remark" 
                        SortExpression="s_remark" />
                    <asp:BoundField DataField="s_kfsj_s" HeaderText="s_kfsj_s" 
                        SortExpression="s_kfsj_s" />
                    <asp:BoundField DataField="s_kfsj_e" HeaderText="s_kfsj_e" 
                        SortExpression="s_kfsj_e" />
                </Columns>
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSourceSB" runat="server" 
                ConnectionString="<%$ ConnectionStrings:LabInfoManageSystemConnectionString %>" 
                
        SelectCommand="SELECT sbInfo.sbID, sbInfo.s_jfID, jfInfo.j_Name, sbInfo.s_class, classInfo.c_Name, sbInfo.s_Name, sbInfo.s_zy, sbInfo.s_remark, sbInfo.s_kfsj_s, sbInfo.s_kfsj_e FROM sbInfo INNER JOIN jfInfo ON sbInfo.s_jfID = jfInfo.jfID INNER JOIN classInfo ON sbInfo.s_class = classInfo.cID"></asp:SqlDataSource>
        
</asp:Content>

